USE [DSRSystem]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spGetKeyESGIssueTemplates]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[spGetKeyESGIssueTemplates]
GO

CREATE PROCEDURE [dbo].[spGetKeyESGIssueTemplates]
AS
BEGIN
	SELECT Id, Text AS Name, ExternalId, Description
	FROM dbo.KeyESGIssues
	ORDER BY Name
END
GO


